|
Proposal for Changes in the Company Information System
Keclík, David ; Neuwirth, Bernard (referee) ; Dydowicz, Petr (advisor)
The main aim of this diploma thesis is to propose for changes in the company information system. Document content is focuse on analyse, implementation and using data warehouse and usage advance to optimaze methods for achievement added value to users. The first part of this thesis is focused on choice of suitable concept of data warehouse, implementation and possible problems. In the second part, I compare assets of this system with costs for development and administration.
|
|
Design of Data Warehouse
Szkuta, David ; Neuwirth, Bernard (referee) ; Dydowicz, Petr (advisor)
This diploma thesis deals with the design of a data warehouse that stores events created in the mobile app. The goal was to design an alternative to the current solution. The thesis explains concepts, mainly data warehouse terminology, which are used in subsequent chapters. An analysis of the current solution is conducted, and as well as research of available data warehouse and ETL services. Based on the results of the analysis, a suitable new solution is chosen, implemented, and tested.
|
|
OLAP Data Storage Methods
Dittrich, Petr ; Kroulík, Jan (referee) ; Hruška, Tomáš (advisor)
The topic of the bachelor work is the OLAP core implementation for the data storage space. All theoretical facts about the data storage space are discussed at the start. The form of metadata elements storage and the OLAP cubes creating are described in the following part. And finally, in the last chapter, it is precisely shown how to create a cube in this system.
|
|
Administration of development documetation over WWW I
Kolář, Miroslav ; Sysel, Petr (referee) ; Balík, Miroslav (advisor)
Master`s thesis is based on the assignment of company Honeywell to create integral system for saving and management of development documentation. Designed system will introduce data warehouse with transparent display of documents being connected with development of customer’s requirements, products and tests, test runs. Solution consists of two parts: A – Requirements and Products and B – Tests, Test runs and Person, whereas Master`s thesis deals with the part B. For system creation utilities of following programming languages were used HTML, PHP, JavaScript and database system MySQL. In the first phase was designed database structure (tables and relations between them). Except that was designed structure for authorization algorithm and integral concept of whole application was created. The second phase is realization. At first are created supporting algorithms. It is servicing database by functions, uniform displaying results from database and authorized access of users to the application. Further data library for integral display data forms, based on used template system Smarty and other libraries, f.e. attribution of the files to records in SQL tables. Important part was implementation of designed database system and related programs. In Tests and Test runs there is user interface established and individual relations between them. According to assignment all fundamental programs were designed together with support instruments. Individual source files are saved in transparent structure of folders, so this structure is possible to apply on any computer, where are installed programs to web hosting. The result of Master`s thesis is then integrated progress report together with functional source codes.
|
|
OLAP Reports Model Creating Based on Metadata
Franek, Zdenko ; Jirák, Ota (referee) ; Ruttkay, Ladislav (advisor)
An important part of knowledge of report creator is knowledge of database schema and database query language, from which the data for report are extracted. In the reporting services for database systems and Business Intelligence systems initiative arises to separate the position of database specialist from the position of reports maker. One of the solutions offers using metadata interlayer between the database schema and report. This interlayer is called the report model. Its use is not currently supported in the process of reporting, or is only very limited. The aim of this thesis is to suggest the possibility of using the report model in the process of building reports with an emphasis on the OLAP analysis.
|
| |
| |
|
Business Intelligence Solution Proposition for Personnel Agency
Ondruš, Erik ; Janata, Michal (referee) ; Luhan, Jan (advisor)
This bachelor thesis deals with creation, optimization of data model and making of Data Warehouse for personnel agency. The outcome of the thesis will be reports for company management, which should support its decision-making or streamline of chosen company processes. The first section describes theoretical basics of the stated topic. The next chapter focuses on analyzing current situation, collecting requirements for new system and in conclusion my own solution draft.
|
| |
| |